SongAlbumRecording
Down for Double Retrospective Sessions, The 4656
   "Swing Era, Music of 1942-1944 5331

SELECT PCS.Name AS "Song", ALB.Name AS "Album", REC.ID AS "Recording" FROM Recordings REC JOIN Pieces PCS ON PCS.ID = REC.Piece_FK JOIN Albums ALB ON ALB.ID = REC.ALBUM_FK WHERE PCS. Name = "Down for Double"